FalgoDividends
Description
SpiderRock Falgo Dividends records provide a combined historical and forward-looking cash dividend schedule for global equity listings. Each record describes a single dividend event for one security in one payment currency, and carries the announcement, ex-dividend, record and payment dates together with the dividend amount per share and a prediction interval around it. The divSource column identifies whether a record is a model projection, a dividend the issuer has declared, or a realized payment, so a single series can be read across both past and future periods. Securities whose holders may elect the currency they are paid in contribute one record per electable currency.
Schema Definition
| Field Name | Data Type | Description |
|---|---|---|
| ticker_at | string | Underlying asset type |
| ticker_ts | string | Underlying ticker source |
| ticker_tk | string | Underlying ticker |
| divSequenceId | string | Identifier of the dividend within the security's calendar year - regular dividends are numbered sequentially, so 202503 is the third regular dividend of 2025, while special dividends carry an S before the ordinal, so 2025S1 is the first special dividend of 2025 |
| payCurrency | string | Currency the dividend is expected to be paid in |
| srSecID | bigint | SpiderRock security ID - not resolved for this dataset and published as 0 |
| ediSecID | bigint | Vendor security ID - the recommended key for joining these records to other sources, as it is stable across ticker renames and exchange migrations |
| isin | string | ISIN of the security |
| exchange | string | Vendor exchange code identifying the listing, for example USNYSE or USNASD - this is not an ISO MIC |
| divKind | string | Dividend kind (e.g. CASH, SPECIAL) |
| divFreq | string | Dividend payment frequency (e.g. QUARTERLY, MONTHLY, SEMI, ANNUAL) |
| divSource | string | Origin of the record - Forecasted for a model projection, Announced for a dividend the issuer has declared, and Actual for a realized dividend. Use this column to tell the three apart; a zero-width confidence interval does not identify a record as announced or realized |
| annDate | date | Announcement date |
| exDate | date | Ex-dividend date |
| recordDate | date | Record date |
| payDate | date | Payment date |
| divAmount | double | Dividend amount per share, expressed in declCurrency |
| confidenceLow | double | Lower bound of the 90% prediction interval around divAmount - 0 on Announced and Actual records, which carry no prediction interval |
| confidenceHigh | double | Upper bound of the 90% prediction interval around divAmount - 0 on Announced and Actual records, which carry no prediction interval |
| declCurrency | string | Currency the issuer declares the dividend in |
| isDefaultPayCurrency | string | Yes when payCurrency is the issuer's default election for this dividend, No when it is an alternative election available to holders |
| isFranked | string | Yes when the dividend carries franking credits under Australian dividend imputation |
| bundle | int | Subscription tier indicator - reserved, currently published as 0 |
| forecastTime | timestamp | Time the record was produced |